[dbo].[FieldDesignSectionLookup]

Property	Value
Heap
Row Count	0
Created	10:31:22 AM Tuesday, March 02, 2010
Last Modified	1:17:32 PM Thursday, February 23, 2012

Property

Value

Heap

Row Count

Created

10:31:22 AM Tuesday, March 02, 2010

Last Modified

1:17:32 PM Thursday, February 23, 2012

	Name	Data Type	Max Length (Bytes)
	FieldSectionId	int	4
$Indexes iWC: TableName\FieldName$	TableName	varchar(30)	30
$Indexes iWC: TableName\FieldName$	FieldName	varchar(30)	30
	SortOrder	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

FieldSectionId

int

$Indexes iWC: TableName\FieldName$

TableName

varchar(30)

$Indexes iWC: TableName\FieldName$

FieldName

varchar(30)

SortOrder

int

Name	Columns
iWC	TableName, FieldName
IX_FieldDesignSectionLookup_FieldSectionId	FieldSectionId

Name

Columns

iWC

TableName, FieldName

IX_FieldDesignSectionLookup_FieldSectionId

FieldSectionId

Name	Columns
FK_FieldDesignSectionLookup_FieldSection	FieldSectionId->[dbo].[FieldSection].[FieldSectionId]

Name

Columns

FK_FieldDesignSectionLookup_FieldSection

FieldSectionId->[dbo].[FieldSection].[FieldSectionId]

SQL Script

CREATE TABLE [dbo].[FieldDesignSectionLookup]
(
[FieldSectionId] [int] NOT NULL,
[TableName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FieldName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SortOrder] [int] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [IX_FieldDesignSectionLookup_FieldSectionId] ON [dbo].[FieldDesignSectionLookup] ([FieldSectionId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[FieldDesignSectionLookup] ([TableName], [FieldName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FieldDesignSectionLookup] ADD CONSTRAINT [FK_FieldDesignSectionLookup_FieldSection] FOREIGN KEY ([FieldSectionId]) REFERENCES [dbo].[FieldSection] ([FieldSectionId])
GO